﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class ADFinance : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["ADUser"] == null)
        {
            Response.Redirect("Advertisement.aspx");
        }
        this.SqlDataSource1.SelectCommand = "SELECT [RemainMoney], [Cent] FROM [GowllUsers] WHERE [ID]="+Session["ADUserID"];
        this.SqlDataSource2.SelectCommand = "SELECT [ID], [AdInfo], [Price], [StartDate],[EndDate],[ShowCount] FROM [GowllADOrders] WHERE [Payed]=1 and [UserID]=" + Session["ADUserID"] + " ORDER BY [ID] DESC ";
        this.GridView1.DataBind();
    }
}
